<?php
    $host='localhost';
    $dbname='test';
    $username='root';
    $passwd='root';
    $dsn="mysql:host=$host;dbname=$dbname";
    $pdo = new PDO($dsn,$username,$passwd);  
    //$count =  $pdo->exec("CREATE TABLE test1(id int(10), value varchar(20))");
    $pdo->setAttribute(PDO::ATTR_CASE, PDO::CASE_NATURAL);
    $count =  $pdo->query("show columns from test1");
    $count->setFetchMode(PDO::FETCH_ASSOC);
    print_r($count);
    $rows = $count->fetchAll();
    var_dump($rows);

